package com.edee.bigday.ware.config;

import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import com.baomidou.mybatisplus.extension.plugins.pagination.optimize.JsqlParserCountOptimize;
import com.zaxxer.hikari.HikariDataSource;
import io.seata.rm.datasource.DataSourceProxy;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;
import org.springframework.util.StringUtils;

import javax.sql.DataSource;

@EnableTransactionManagement
@MapperScan("com.edee.bigday.ware.dao")
//上面和数据库相关的两项注解，移自com/edee/bigday/ware/BigdayWareApplication.java。
@Configuration
public class WareMyBatisConfig {
    //引入MyBatis-Plus的分页插件
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
        // 设置请求的页面大于最大页后操作， true调回到首页，false 继续请求  默认false
        // paginationInterceptor.setOverflow(false);
        paginationInterceptor.setOverflow(true);
        // 设置最大单页限制数量，默认 500 条，-1 不受限制
        // paginationInterceptor.setLimit(500);
        paginationInterceptor.setLimit(1000);
        // 开启count的join优化,只针对部分left join:
        paginationInterceptor.setCountSqlParser(new JsqlParserCountOptimize(true));
//        paginationInterceptor.setCountSqlParser(new JsqlParserCountOptimize(false));
        //上述join优化无论设置为true或false，均 会导致No core dump will be written.
        // Minidumps are not enabled by default on client versions of Windows异常。
        return paginationInterceptor;
//        return new PaginationInterceptor();
    }

    //配置自定义代理数据源
    @Autowired
    DataSourceProperties dataSourceProperties;

    public DataSource datasource(DataSourceProperties dataSourceProperties){
        //return (T) properties.initializeDataSourceBuilder().type(type).build();
        HikariDataSource dataSource = dataSourceProperties.initializeDataSourceBuilder().type(HikariDataSource.class).build();
        if (StringUtils.hasText(dataSourceProperties.getName())) {
            dataSource.setPoolName(dataSourceProperties.getName());
        }
        //使用Seata的数据源代理DataSourceProxy包装自定义数据源：
        return new DataSourceProxy(dataSource);
    }
}
